SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:7 WILLOW SPRING LANE- Spacious, well-maintained home on a large private lot in a quiet neighborhood within walking distance of downtown Hanover. The Girl Brook Trail and Dartmouth's Practice Golf Course are adjacent the property providing acres of space to recreate. The house interiors are spacious and bright, including a large living room with central fireplace and views over the back lawn on the main level. There is a large, well-appointed eat-in kitchen that adjoins a formal dining room, while the primary bedroom suite on this level features a generous en suite bathroom, changing area, and plenty of wardrobe space. There is also a second en suite bedroom on this floor providing plenty of options for one-floor living. The lower walkout level offers several versatile bright and spacious rooms including a family room, rec room, and two additional bedrooms that share a full bathroom. Additionally, there is a large central laundry room, workshop, and additional storage space. Outside the home are level lawns, mature landscaping, and a sizable deck to enjoy during warmer weather. With walking trails, cross country skiing, and more on the Girl Brook Trail network and shops, restaurants, and area schools just minutes away, this charming family home is a true Hanover gem. A few photos are virtually staged.
Description:Welcome to the best of golf course living! This upscale home on Eastman Golf Links is on the market for the very first time. A custom Yankee Barn home on the 2nd fairway with golf course views throughout many rooms. This spacious 4,397 SF home offers sleeping quarters on each of its 3 finished levels. Featuring a statement living room with cathedral ceilings, a 2-story window display, double-sided fireplace, and the quintessential wood beams highlighting its architecture. A beautiful kitchen with an island and stainless steel appliances sits opposite the dining area with sliders to a cozy sunroom. Retreat to the main level Primary bedroom suite with its own bath and deck access. You’ll also find an office with skylights, family room with deck access, and a half bath on the main level. The upper level has a loft area + 2 bedrooms and a full bath with separate tub and shower. The finished walkout lower level is an expansive space for gatherings and game nights. It includes a family room area with built-ins, a wet bar with seating, a built-in desk with storage, and a rec area. This grand home is complete with a 2-car attached garage, tiled mudroom, level lot and paved driveway. Eastman offers lake activities, golf, cross-country skiing, tennis, pickleball, walking trails, an indoor pool, fitness center and more. All this in the heart of the Dartmouth - Lake Sunapee Region with easy access to I-89.
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.
Description:Beautifully designed and meticulously crafted contemporary cape in a private country setting. Bright sunshine fills this home adding to the atmosphere of complete comfort. Large family room is open to the excellent kitchen, there is a formal dining room with more built-ins and a gorgeous vaulted ceiling living room with fireplace. Cozy sunroom completes the first floor. Upstairs there's a gracious primary suite with balcony, 2 more bedroom, a quiet study and a convenient laundry room. The grounds are fantastic with mature gardens which can be enjoyed from the spacious covered front porch, deck off the kitchen or the stone patio. A wonderful Post and Beam barn is perfect for a workshop, antique car storage or studio space. A very special offering! Showings begin Wednesday, March 12th.
Description:A beautiful and unique piece of property just a 10 minute drive to downtown Lebanon! Located on 26 acres at the top of Eastman Hill, this property provides plenty of space, privacy and spectacular views from everywhere in the house! Recent renovations, updates and fresh paint make it move-in ready!